由 macro 发布于: 2001-03-04 15:28

Setting up the logMiner Session

Once you have created a dictionary file ,you can begin analyzing redo log .The first step is to specify the log files that you want to analyze , using the DBMS_LOGMNR.ADD_LOGFILE procedure.

Use the following constants:
1.DBMS_LOGMNR.NEW creats a new list and specifies the first log file.
2.DBMS_LOGMNR.ADDFILE adds additional log files to the list.
3.DBMS_LOGMNR.REMOVEFILE removes redo logs from the list.

eg.
Set up the V$LOGMNR_CONTENTS view:

Initialze a new list and specify the first log file.

EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\ora815\oradata\v815\redo01a.log',DBMS_LOGMNR.NEW);

Add additional files to the list

EXECUTE DBMS_LOGMNR.ADD_LOGFILE('C:\ora815\oradata\v815\redo02a.log',DBMS_LOGMNR.ADDFILE);

LogMiner can analyze both online and archived log files.



__________________

谢谢你抽时间看我的发言，

Macro Zeng

==================================

我正在学习 Oracle ,坚持每天写读书笔记